package com.woniuxy.oldmanapi.mapper;

import com.woniuxy.oldmanapi.entity.Room;
import com.woniuxy.oldmanapi.xvo.RoomDyaVo;
import com.woniuxy.oldmanapi.entity.Storey;
import com.woniuxy.oldmanapi.vo.RoomVo;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

import java.util.List;

import java.util.List;

@Repository
public interface RoomMapper extends Mapper<Room> {
    List<RoomDyaVo> selectRoomDyaVoBySid(int storeyId);

    List<RoomDyaVo> selectRoomDyaVoBySid0(int storeyId);
    List<RoomDyaVo> selectRoomDyaVoBySid1(int storeyId);
    List<RoomVo> selectById(int id);
    @Select("select count(*) from room where storey_id = #{id}")
    int selectNum(int id);
    List<Room> selectByStoreyIdYSW(@Param("buildingId") Integer buildingId, @Param("storeyId")Integer storeyId);

}